home *** CD-ROM | disk | FTP | other *** search
/ Windows 95 API Bible / Windows 95 API Bible 3 Disc Set.iso / Win32 API Bible Book 3 of 3 / CHAPTER2 / DATASRC.C next >
C/C++ Source or Header  |  1996-04-26  |  7KB  |  214 lines
  1.  
  2. #include <windows.h>  
  3. #include "datasrc.h"  
  4. #include "sqlext.h"
  5.  
  6. #if defined (WIN32)
  7.     #define IS_WIN32 TRUE
  8. #else
  9.     #define IS_WIN32 FALSE
  10. #endif
  11.  
  12. #define IS_NT      IS_WIN32 && (BOOL)(GetVersion() < 0x80000000)
  13. #define IS_WIN32S  IS_WIN32 && (BOOL)(!(IS_NT) && (LOBYTE(LOWORD(GetVersion()))<4))
  14. #define IS_WIN95   (BOOL)(!(IS_NT) && !(IS_WIN32S)) && IS_WIN32
  15.  
  16. HINSTANCE hInst;   // current instance
  17.  
  18. LPCTSTR lpszAppName = "MyApp";
  19. LPCTSTR lpszTitle   = "SQLDataSources()"; 
  20.  
  21.  
  22. BOOL RegisterWin95( CONST WNDCLASS* lpwc );
  23.  
  24.  
  25. int APIENTRY WinMain( HINSTANCE hInstance, HINSTANCE hPrevInstance,
  26.                       LPTSTR lpCmdLine, int nCmdShow)
  27. {
  28.    MSG      msg;
  29.    HWND     hWnd; 
  30.    WNDCLASS wc;
  31.  
  32.    wc.style         = CS_HREDRAW | CS_VREDRAW;
  33.    wc.lpfnWndProc   = (WNDPROC)WndProc;       
  34.    wc.cbClsExtra    = 0;                      
  35.    wc.cbWndExtra    = 0;                      
  36.    wc.hInstance     = hInstance;              
  37.    wc.hIcon         = LoadIcon (hInstance, lpszAppName); 
  38.    wc.hCursor       = LoadCursor(NULL, IDC_ARROW);
  39.    wc.hbrBackground = (HBRUSH)(COLOR_WINDOW+1);
  40.    wc.lpszMenuName  = lpszAppName;              
  41.    wc.lpszClassName = lpszAppName;              
  42.  
  43.    if ( IS_WIN95 )
  44.    {
  45.       if ( !RegisterWin95( &wc ) )
  46.          return( FALSE );
  47.    }
  48.    else if ( !RegisterClass( &wc ) )
  49.       return( FALSE );
  50.  
  51.    hInst = hInstance; 
  52.  
  53.    hWnd = CreateWindow( lpszAppName, 
  54.                         lpszTitle,    
  55.                         WS_OVERLAPPEDWINDOW, 
  56.                         CW_USEDEFAULT, 0, 
  57.                         CW_USEDEFAULT, 0,  
  58.                         NULL,              
  59.                         NULL,              
  60.                         hInstance,         
  61.                         NULL               
  62.                       );
  63.  
  64.    if ( !hWnd ) 
  65.       return( FALSE );
  66.  
  67.    ShowWindow( hWnd, nCmdShow ); 
  68.    UpdateWindow( hWnd );         
  69.  
  70.    while( GetMessage( &msg, NULL, 0, 0) )   
  71.    {
  72.       TranslateMessage( &msg ); 
  73.       DispatchMessage( &msg );  
  74.    }
  75.  
  76.    return( msg.wParam ); 
  77. }
  78.  
  79.  
  80. BOOL RegisterWin95( CONST WNDCLASS* lpwc )
  81. {
  82.    WNDCLASSEX wcex;
  83.  
  84.    wcex.style         = lpwc->style;
  85.    wcex.lpfnWndProc   = lpwc->lpfnWndProc;
  86.    wcex.cbClsExtra    = lpwc->cbClsExtra;
  87.    wcex.cbWndExtra    = lpwc->cbWndExtra;
  88.    wcex.hInstance     = lpwc->hInstance;
  89.    wcex.hIcon         = lpwc->hIcon;
  90.    wcex.hCursor       = lpwc->hCursor;
  91.    wcex.hbrBackground = lpwc->hbrBackground;
  92.    wcex.lpszMenuName  = lpwc->lpszMenuName;
  93.    wcex.lpszClassName = lpwc->lpszClassName;
  94.  
  95.    // Added elements for Windows 95.
  96.    //...............................
  97.    wcex.cbSize = sizeof(WNDCLASSEX);
  98.    wcex.hIconSm = LoadImage(wcex.hInstance, lpwc->lpszClassName, 
  99.                             IMAGE_ICON, 16, 16,
  100.                             LR_DEFAULTCOLOR );
  101.             
  102.    return RegisterClassEx( &wcex );
  103. }
  104.  
  105.  
  106. LRESULT CALLBACK WndProc( HWND hWnd, UINT uMsg, WPARAM wParam, LPARAM lParam )
  107. {
  108. static HENV hEnv  = NULL;
  109. static HWND hList = NULL;
  110.  
  111.    switch( uMsg )
  112.    {
  113.       case WM_CREATE  :
  114.               SQLAllocEnv( &hEnv );
  115.  
  116.               hList = CreateWindow( "LISTBOX", "",    
  117.                                     WS_CHILD | LBS_STANDARD | 
  118.                                     WS_VISIBLE | LBS_NOINTEGRALHEIGHT, 
  119.                                     0, 0, 
  120.                                     0, 0,  
  121.                                     hWnd,              
  122.                                     (HMENU)101,              
  123.                                     hInst,         
  124.                                     NULL               
  125.                                   );
  126.  
  127.               break;
  128.  
  129.       case WM_SIZE :
  130.               MoveWindow( hList, 0, 0, LOWORD( lParam ), HIWORD( lParam ), TRUE );
  131.               break; 
  132.               
  133.       case WM_COMMAND :
  134.               switch( LOWORD( wParam ) )
  135.               {
  136.                  case IDM_TEST :
  137.                         {
  138.                            UCHAR   szDSN[ SQL_MAX_DSN_LENGTH+1 ];
  139.                            UCHAR   szDescription[ 256 ];
  140.                            SWORD   wDSNLen;
  141.                            SWORD   wDesLen;
  142.                            RETCODE retCode;
  143.  
  144.                            // Retrieve the first data source name.
  145.                            //.....................................
  146.                            retCode = SQLDataSources( hEnv, SQL_FETCH_FIRST, 
  147.                                                      szDSN, SQL_MAX_DSN_LENGTH+1, &wDSNLen,
  148.                                                      szDescription, 256, &wDesLen );
  149.  
  150.                            // Continue retrieving data source names
  151.                            // until there are no more.
  152.                            //......................................
  153.                            while( retCode == SQL_SUCCESS || retCode == SQL_SUCCESS_WITH_INFO )
  154.                            {
  155.                               SendMessage( hList, LB_ADDSTRING, 0, (LPARAM)szDSN );
  156.  
  157.                               // retrieve the next data source name.
  158.                               //....................................
  159.                               retCode = SQLDataSources( hEnv, SQL_FETCH_NEXT, 
  160.                                                      szDSN, SQL_MAX_DSN_LENGTH+1, &wDSNLen,
  161.                                                      szDescription, 256, &wDesLen );
  162.  
  163.                            }
  164.                         }
  165.                         break;
  166.  
  167.                  case IDM_ABOUT :
  168.                         DialogBox( hInst, "AboutBox", hWnd, (DLGPROC)About );
  169.                         break;
  170.  
  171.                  case IDM_EXIT :
  172.                         DestroyWindow( hWnd );
  173.                         break;
  174.               }
  175.               break;
  176.       
  177.       case WM_DESTROY :
  178.               PostQuitMessage(0);
  179.               SQLFreeEnv( hEnv );
  180.               break;
  181.  
  182.       default :
  183.             return( DefWindowProc( hWnd, uMsg, wParam, lParam ) );
  184.    }
  185.  
  186.    return( 0L );
  187. }
  188.  
  189.  
  190. LRESULT CALLBACK About( HWND hDlg,           
  191.                         UINT message,        
  192.                         WPARAM wParam,       
  193.                         LPARAM lParam)
  194. {
  195.    static  HFONT hfontDlg;
  196.  
  197.    switch (message) 
  198.    {
  199.        case WM_INITDIALOG: 
  200.                return (TRUE);
  201.  
  202.        case WM_COMMAND:                              
  203.                if (   LOWORD(wParam) == IDOK         
  204.                    || LOWORD(wParam) == IDCANCEL)    
  205.                {
  206.                        EndDialog(hDlg, TRUE);        
  207.                        return (TRUE);
  208.                }
  209.                break;
  210.    }
  211.  
  212.    return (FALSE); 
  213. }
  214.